/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50731
 Source Host           : 127.0.0.1:3306
 Source Schema         : pc28

 Target Server Type    : MySQL
 Target Server Version : 50731
 File Encoding         : 65001

 Date: 02/11/2021 09:53:41
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
  `id` int(10) NOT NULL,
  `k` varchar(128) NOT NULL,
  `v` text NOT NULL,
  `remark` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `config_idx` (`k`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of config
-- ----------------------------
BEGIN;
INSERT INTO `config` VALUES (140727, 'fxg_trade_decrypt_user_ids', '1693,24802', '上传发货公司物流走数据库中的配置');
INSERT INTO `config` VALUES (140728, 'version', '20210728171441', NULL);
COMMIT;

-- ----------------------------
-- Table structure for express_company
-- ----------------------------
DROP TABLE IF EXISTS `express_company`;
CREATE TABLE `express_company` (
  `id` bigint(18) NOT NULL,
  `name` varchar(32) DEFAULT NULL,
  `code` varchar(32) NOT NULL,
  `custom_name` varchar(32) DEFAULT NULL,
  `express_company_jd_id` bigint(20) DEFAULT '0',
  `source` int(11) DEFAULT '0' COMMENT '0表示tb、1表示jd',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `consign_code` varchar(32) NOT NULL COMMENT '快递公司发货资源编码',
  `jd_cp_code` varchar(16) DEFAULT NULL COMMENT '京东cpCode',
  `shopee_logistic_id` int(4) DEFAULT '0' COMMENT '虾皮物流id',
  PRIMARY KEY (`id`),
  KEY `idx_code` (`code`(8))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of express_company
-- ----------------------------
BEGIN;
INSERT INTO `express_company` VALUES (1, '中国邮政', 'POST', '邮政平邮', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'POST', '[null]', 0);
INSERT INTO `express_company` VALUES (2, 'EMS', 'EMS', 'EMS标准快递', 3668, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'EMS', '[null]', 0);
INSERT INTO `express_company` VALUES (3, 'EMS经济快递', 'EYB', 'EMS经济快递', 465, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'EYB', '[null]', 0);
INSERT INTO `express_company` VALUES (90, '晟邦物流', 'CHENGBANG', '晟邦物流', 0, 0, '2019-03-07 15:54:06', '2019-03-07 15:54:12', 'CHENGBANG', '[null]', 0);
INSERT INTO `express_company` VALUES (100, '申通快递', 'STO', '申通快递', 470, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'STO', '[null]', 435);
INSERT INTO `express_company` VALUES (101, '圆通速递', 'YTO', '圆通速递', 463, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'YTO', 'YTO', 285);
INSERT INTO `express_company` VALUES (102, '韵达快递', 'YUNDA', '韵达快递', 1327, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'YUNDA', 'YUNDA', 222);
INSERT INTO `express_company` VALUES (103, '宅急送', 'ZJS', '宅急送', 1409, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'ZJS', 'ZJS', 0);
INSERT INTO `express_company` VALUES (105, '百世物流', 'BEST', '百世物流', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'BEST', '[null]', 0);
INSERT INTO `express_company` VALUES (106, '联邦快递', 'FEDEX', '联邦快递', 2096, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'FEDEX', '[null]', 0);
INSERT INTO `express_company` VALUES (107, '德邦物流', 'DBL', '德邦物流', 2130, 0, '2014-08-13 10:43:39', '2014-08-13 10:43:39', 'DBL', '[null]', 0);
INSERT INTO `express_company` VALUES (108, '华强物流', 'SHQ', '华强物流', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'SHQ', '[null]', 0);
INSERT INTO `express_company` VALUES (130, '拼多多:如风达', 'RFD', '拼多多:如风达', 0, 0, '2019-03-07 16:52:26', '2019-03-07 16:52:32', 'RFD', '[null]', 0);
INSERT INTO `express_company` VALUES (132, '邮政快递包裹', 'YZXB', '邮政快递包裹', 0, 0, '2019-03-07 16:55:42', '2019-03-07 16:55:46', 'YZXB', '[null]', 0);
INSERT INTO `express_company` VALUES (140, '南京晟邦', 'NJCHENGBANG', '南京晟邦', 0, 0, '2019-03-07 17:03:12', '2019-03-07 17:03:17', 'NJCHENGBANG', '[null]', 0);
INSERT INTO `express_company` VALUES (142, '万象物流', 'WXWL', '万象物流', 0, 0, '2019-03-07 17:05:24', '2019-03-07 17:05:28', 'WXWL', '[null]', 0);
INSERT INTO `express_company` VALUES (148, '安达信', 'ADX', '安达信', 0, 0, '2019-03-07 17:10:07', '2019-03-07 17:10:13', 'ADX', '[null]', 0);
INSERT INTO `express_company` VALUES (149, '海外快递', 'HWKD', '海外快递', 0, 0, '2019-03-07 17:56:13', '2019-03-07 17:56:18', 'HWKD', '[null]', 0);
INSERT INTO `express_company` VALUES (154, '黄马甲', 'HUANGMAJIA', '黄马甲', 0, 0, '2019-03-07 17:57:26', '2019-03-07 17:57:31', 'HUANGMAJIA', '[null]', 0);
INSERT INTO `express_company` VALUES (156, '亚马逊物流', 'YAMAXUNWULIU', '亚马逊物流', 0, 0, '2019-03-08 10:04:15', '2019-03-08 10:04:19', 'YAMAXUNWULIU', '[null]', 0);
INSERT INTO `express_company` VALUES (163, '芝麻开门', 'ZMKM', '芝麻开门', 0, 0, '2019-03-08 10:07:00', '2019-03-08 10:07:04', 'ZMKM', '[null]', 0);
INSERT INTO `express_company` VALUES (165, '汇通小红马', 'HTXMJ', '汇通小红马', 0, 0, '2019-03-08 10:07:46', '2019-03-08 10:07:51', 'HTXMJ', '[null]', 0);
INSERT INTO `express_company` VALUES (180, '拼多多:其他', 'SELF', '拼多多:其他', 0, 0, '2019-03-08 10:09:47', '2019-03-08 10:09:51', 'SELF', '[null]', 0);
INSERT INTO `express_company` VALUES (187, '青岛安捷', 'ANJELEX', '青岛安捷', 0, 0, '2019-03-08 10:14:58', '2019-03-08 10:15:02', 'ANJELEX', '[null]', 0);
INSERT INTO `express_company` VALUES (205, '远成快运', 'YCGWL', '远成快运', 0, 0, '2019-03-08 10:23:13', '2019-03-08 10:23:17', 'YCGWL', '[null]', 0);
INSERT INTO `express_company` VALUES (211, '中邮速递', 'ZHONGYOUWULIU', '中邮速递', 0, 0, '2019-03-08 10:28:37', '2019-03-08 10:28:41', 'ZHONGYOUWULIU', '[null]', 0);
INSERT INTO `express_company` VALUES (213, 'EMS-国际件', 'INTEREMS', 'EMS-国际件', 0, 0, '2019-03-08 10:30:56', '2019-03-08 10:31:00', 'INTEREMS', '[null]', 0);
INSERT INTO `express_company` VALUES (214, '中铁物流(飞豹)', 'ZTKY', '中铁物流(飞豹)', 0, 0, '2019-03-08 10:37:52', '2019-03-08 10:37:57', 'ZTKY', '[null]', 0);
INSERT INTO `express_company` VALUES (217, 'Flash Express', 'FLASH', 'Flash Express', 0, 0, '2019-03-08 10:40:32', '2019-03-08 10:40:35', 'FLASH', '[null]', 0);
INSERT INTO `express_company` VALUES (227, '日日顺物流', 'RRS', '日日顺物流', 0, 0, '2019-03-08 10:42:04', '2019-03-08 10:42:08', 'RRS', '[null]', 0);
INSERT INTO `express_company` VALUES (228, '苏宁快递', 'SNWL', '苏宁快递', 0, 0, '2019-03-08 10:43:12', '2019-03-08 10:43:15', 'SNWL', '[null]', 0);
INSERT INTO `express_company` VALUES (231, '拼多多:微特派', 'WEITEPAI', '拼多多:微特派', 0, 0, '2019-03-08 10:55:56', '2019-03-08 10:55:59', 'WEITEPAI', '[null]', 0);
INSERT INTO `express_company` VALUES (232, 'AAE全球专递', 'MYAAE', 'AAE全球专递', 0, 0, '2019-03-08 10:59:20', '2019-03-08 10:59:24', 'MYAAE', '[null]', 0);
INSERT INTO `express_company` VALUES (233, 'Aramex', 'ARAMEX', 'Aramex', 0, 0, '2019-03-08 11:06:11', '2019-03-08 11:06:15', 'ARAMEX', '[null]', 0);
INSERT INTO `express_company` VALUES (239, 'DHL中国', 'DHLCN', 'DHL中国', 0, 0, '2019-03-08 11:08:21', '2019-03-08 11:08:24', 'DHLCN', '[null]', 0);
INSERT INTO `express_company` VALUES (246, 'UPS', 'UPS', 'UPS', 0, 0, '2019-03-08 11:09:15', '2019-03-08 11:09:19', 'UPS', '[null]', 0);
INSERT INTO `express_company` VALUES (262, '传喜物流', 'CXCOD', '传喜物流', 0, 0, '2019-03-08 11:11:07', '2019-03-08 11:11:10', 'CXCOD', '[null]', 0);
INSERT INTO `express_company` VALUES (264, '递四方', '4PX', '递四方', 0, 0, '2019-03-08 11:13:01', '2019-03-08 11:13:05', '4PX', '[null]', 0);
INSERT INTO `express_company` VALUES (273, '恒路物流', 'HLWL', '恒路物流', 0, 0, '2019-03-08 11:14:49', '2019-03-08 11:14:52', 'HLWL', '[null]', 0);
INSERT INTO `express_company` VALUES (275, '加运美', 'TMS56', '加运美', 0, 0, '2019-03-08 11:15:30', '2019-03-08 11:15:32', 'TMS56', '[null]', 0);
INSERT INTO `express_company` VALUES (277, '佳怡物流', 'JIAYI', '佳怡物流', 0, 0, '2019-03-08 11:19:57', '2019-03-08 11:20:01', 'JIAYI', '[null]', 0);
INSERT INTO `express_company` VALUES (281, '京广速递', 'CP449455', '京广速递', 0, 0, '2019-03-08 11:22:49', '2019-03-08 11:22:53', 'DISTRIBUTOR_13462882', '[null]', 0);
INSERT INTO `express_company` VALUES (291, '民航快递', 'CAE', '民航快递', 0, 0, '2019-03-08 11:28:38', '2019-03-08 11:28:41', 'CAE', '[null]', 0);
INSERT INTO `express_company` VALUES (305, '盛丰物流', 'FJSFWLJTYXGS', '盛丰物流', 0, 0, '2019-03-08 11:31:42', '2019-03-08 11:31:45', 'FJSFWLJTYXGS', '[null]', 0);
INSERT INTO `express_company` VALUES (306, '拼多多:盛辉物流', 'SHENGHUI', '拼多多:盛辉物流', 0, 0, '2019-03-08 11:33:17', '2019-03-08 11:33:20', 'SHENGHUI', '[null]', 0);
INSERT INTO `express_company` VALUES (312, '万家物流', 'MANCOWL', '万家物流', 0, 0, '2019-03-08 11:34:56', '2019-03-08 11:35:00', 'MANCOWL', '[null]', 0);
INSERT INTO `express_company` VALUES (319, '燕文物流', 'YWWL', '燕文物流', 0, 0, '2019-03-08 11:37:58', '2019-03-08 11:38:01', 'YWWL', '[null]', 0);
INSERT INTO `express_company` VALUES (324, '邮政标准快递', 'POSTBBZ', '邮政标准快递', 0, 0, '2019-03-08 11:39:20', '2019-03-08 11:39:23', 'POSTBBZ', '[null]', 0);
INSERT INTO `express_company` VALUES (325, '邮政国际包裹', 'CNPOSTGJ', '邮政国际包裹', 0, 0, '2019-03-08 11:40:51', '2019-03-08 11:40:54', 'CNPOSTGJ', '[null]', 0);
INSERT INTO `express_company` VALUES (335, '优邦国际速运', 'YOUBANG', '优邦国际速运', 0, 0, '2019-03-08 11:42:23', '2019-03-08 11:42:26', 'YOUBANG', '[null]', 0);
INSERT INTO `express_company` VALUES (336, '天际快递', 'TJ', '天际快递', 0, 0, '2019-03-08 11:43:40', '2019-03-08 11:43:43', 'TJ', '[null]', 0);
INSERT INTO `express_company` VALUES (337, '飞洋快递', 'FY', '飞洋快递', 0, 0, '2019-03-08 11:44:20', '2019-03-08 11:44:22', 'FY', '[null]', 0);
INSERT INTO `express_company` VALUES (338, '拼多多:斑马物联网', 'BM', '拼多多:斑马物联网', 0, 0, '2019-03-08 11:45:39', '2019-03-08 11:45:43', 'BM', '[null]', 0);
INSERT INTO `express_company` VALUES (339, '易客满', 'EKM', '易客满', 0, 0, '2019-03-08 11:48:03', '2019-03-08 11:48:07', 'EKM', '[null]', 0);
INSERT INTO `express_company` VALUES (340, '京东大件物流', 'JDKD', '京东大件物流', 0, 0, '2019-03-08 11:49:11', '2019-03-08 11:49:14', 'JDKD', '[null]', 0);
INSERT INTO `express_company` VALUES (341, '速必达', 'SUBIDA', '速必达', 0, 0, '2019-03-08 11:50:06', '2019-03-08 11:50:09', 'SUBIDA', '[null]', 0);
INSERT INTO `express_company` VALUES (342, '东骏快捷', 'DJKJWL', '东骏快捷', 0, 0, '2019-03-08 11:50:44', '2019-03-08 11:50:48', 'DJKJWL', '[null]', 0);
INSERT INTO `express_company` VALUES (344, '韵达快运', 'CN7000001021040', '韵达快运', 731302, 0, '2019-03-08 11:52:59', '2019-03-08 11:53:02', 'DISTRIBUTOR_13421750', '[null]', 767);
INSERT INTO `express_company` VALUES (345, '安能快运', 'CN7000001000869', '安能快运', 0, 0, '2019-03-08 11:53:51', '2019-03-08 11:53:54', 'DISTRIBUTOR_12017865', '[null]', 0);
INSERT INTO `express_company` VALUES (346, '安得物流', 'ANDE', '安得物流', 0, 0, '2019-03-08 11:54:58', '2019-03-08 11:55:02', 'ANDE', '[null]', 0);
INSERT INTO `express_company` VALUES (347, '中粮我买网', 'WM', '中粮我买网', 0, 0, '2019-03-08 11:56:49', '2019-03-08 11:56:52', 'WM', '[null]', 0);
INSERT INTO `express_company` VALUES (348, '壹米滴答', 'YMDD', '壹米滴答', 0, 0, '2019-03-08 13:54:29', '2019-03-08 13:54:33', 'YMDD', '[null]', 0);
INSERT INTO `express_company` VALUES (349, '当当网', 'DD', '当当网', 0, 0, '2019-03-08 13:55:21', '2019-03-08 13:55:25', 'DD', '[null]', 0);
INSERT INTO `express_company` VALUES (350, '品骏', 'PJ', '品骏', 0, 0, '2019-03-08 13:55:59', '2019-03-08 13:56:02', 'PJ', '[null]', 0);
INSERT INTO `express_company` VALUES (351, '承诺达特快', 'OTP', '承诺达特快', 0, 0, '2019-03-08 14:00:27', '2019-03-08 14:00:31', 'OTP', '[null]', 0);
INSERT INTO `express_company` VALUES (352, '安迅物流', 'AXWL', '安迅物流', 0, 0, '2019-03-08 14:01:19', '2019-03-08 14:01:22', 'AXWL', '[null]', 0);
INSERT INTO `express_company` VALUES (354, 'D速物流', 'SDSD', 'D速物流', 0, 0, '2019-03-08 14:02:17', '2019-03-08 14:02:21', 'SDSD', '[null]', 0);
INSERT INTO `express_company` VALUES (500, '中通快递', 'ZTO', '中通快递', 1499, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'ZTO', 'ZTO', 371);
INSERT INTO `express_company` VALUES (502, '百世汇通', 'HTKY', '百世汇通', 1748, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'HTKY', '[null]', 0);
INSERT INTO `express_company` VALUES (504, '天天快递', 'TTKDEX', '天天快递', 2009, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'TTKDEX', '[null]', 0);
INSERT INTO `express_company` VALUES (505, '顺丰速运', 'SF', '顺丰速运', 467, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'SF', 'SF', 541);
INSERT INTO `express_company` VALUES (507, '亚风', 'AIR', '亚风', 323141, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'AIR', '[null]', 0);
INSERT INTO `express_company` VALUES (511, '长宇', 'CYEXP', '长宇', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'CYEXP', '[null]', 0);
INSERT INTO `express_company` VALUES (512, '大田', 'DTW', '大田', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'DTW', '[null]', 0);
INSERT INTO `express_company` VALUES (513, '长发', 'YUD', '长发', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'YUD', '[null]', 0);
INSERT INTO `express_company` VALUES (1016, '中铁快运', 'CRE', '中铁快运(飞豹)', 466, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'CRE', '[null]', 0);
INSERT INTO `express_company` VALUES (1056, '佳吉快递', 'CNEX', '佳吉快递', 2460, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'CNEX', '[null]', 0);
INSERT INTO `express_company` VALUES (1121, '飞远(爱彼西)配送', 'HZABC', '飞远(爱彼西)配送', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'HZABC', '[null]', 0);
INSERT INTO `express_company` VALUES (1137, '东方汇', 'DFH', '东方汇', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'DFH', '[null]', 0);
INSERT INTO `express_company` VALUES (1138, '首业', 'SY', '首业', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'SY', '[null]', 0);
INSERT INTO `express_company` VALUES (1139, '远长', 'YC', '远长', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'YC', '[null]', 0);
INSERT INTO `express_company` VALUES (1185, '黑猫宅急便', 'YCT', '黑猫宅急便', 1549, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'YCT', '[null]', 0);
INSERT INTO `express_company` VALUES (1186, '新邦物流', 'XB', '新邦物流', 2461, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'XB', '[null]', 0);
INSERT INTO `express_company` VALUES (1191, '天地华宇', 'HOAU', '天地华宇', 2462, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'HOAU', '[null]', 0);
INSERT INTO `express_company` VALUES (1192, '能达速递', 'NEDA', '能达速递', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'NEDA', '[null]', 0);
INSERT INTO `express_company` VALUES (1195, '龙邦速递', 'LB', '龙邦速递', 471, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'LB', '[null]', 0);
INSERT INTO `express_company` VALUES (1204, '快捷快递', 'FAST', '快捷快递', 2094, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'FAST', '[null]', 0);
INSERT INTO `express_company` VALUES (1207, '优速快递', 'UC', '优速快递', 1747, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'UC', 'UC', 0);
INSERT INTO `express_company` VALUES (1208, '增益速递', 'QRT', '增益速递', 3044, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'QRT', '[null]', 0);
INSERT INTO `express_company` VALUES (1214, '联昊通', 'LTS', '联昊通', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'LTS', '[null]', 0);
INSERT INTO `express_company` VALUES (1216, '全峰快递', 'QFKD', '全峰快递', 2016, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'QFKD', '[null]', 0);
INSERT INTO `express_company` VALUES (1237, '发网', 'UNIPS', '发网', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'UNIPS', '[null]', 0);
INSERT INTO `express_company` VALUES (1259, '全一快递', 'UAPEX', '全一快递', 2100, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'UAPEX', '[null]', 0);
INSERT INTO `express_company` VALUES (1262, '城市100', 'BJCS', '城市100', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'BJCS', '[null]', 0);
INSERT INTO `express_company` VALUES (1269, '广东EMS', 'GDEMS', '广东EMS', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'GDEMS', '[null]', 0);
INSERT INTO `express_company` VALUES (1270, '加运美速递', 'OTHER', '加运美速递', 0, 0, '2019-05-07 10:46:08', '2019-05-07 10:46:11', 'OTHER', '[null]', 0);
INSERT INTO `express_company` VALUES (1271, '极兔速递', 'JTSD', '极兔速递', 0, 0, '2020-05-05 14:53:53', '2020-05-05 14:53:53', 'JTSD', '[null]', 0);
INSERT INTO `express_company` VALUES (12000, '顺心捷达快运', 'CP471906', '顺心捷达快运', 832230, 0, '2020-05-13 20:50:48', '2020-05-13 20:50:48', 'DISTRIBUTOR_13484485', 'SXJD', 0);
INSERT INTO `express_company` VALUES (15000, '顺丰快运', 'SFKY', '顺丰快运', 0, 0, '2020-06-09 15:37:52', '2020-06-09 15:37:52', 'SFKY', '[null]', 1097);
INSERT INTO `express_company` VALUES (105031, '百世快运', 'BESTQJT', '百世快运', 1748, 0, '2016-10-08 14:56:02', '2016-10-08 14:56:02', 'BESTQJT', '[null]', 0);
INSERT INTO `express_company` VALUES (200143, '国通快递', 'GTO', '国通快递', 2465, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'GTO', '[null]', 0);
INSERT INTO `express_company` VALUES (200427, '飞远配送 ', 'GZLT', '飞远配送 ', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'GZLT', '[null]', 0);
INSERT INTO `express_company` VALUES (200734, '邮政国内小包', 'POSTB', '邮政国内小包', 2170, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'POSTB', 'ZGYZZHDD', 0);
INSERT INTO `express_company` VALUES (200740, 'E速宝', 'ESB', 'E速宝', 1274, 0, '2014-08-13 10:43:39', '2014-08-13 10:43:39', 'ESB', '[null]', 0);
INSERT INTO `express_company` VALUES (201174, '速尔', 'SURE', '速尔快递', 2105, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'SURE', 'SE', 0);
INSERT INTO `express_company` VALUES (202855, '信丰物流', 'XFWL', '信丰物流', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'XFWL', '[null]', 0);
INSERT INTO `express_company` VALUES (202857, '凡宇速递', 'GZFY', '凡宇速递', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'GZFY', '[null]', 0);
INSERT INTO `express_company` VALUES (204900, '居无忧', 'JWY', '居无忧', 1274, 0, '2014-08-13 10:43:39', '2014-08-13 10:43:39', 'JWY', '[null]', 0);
INSERT INTO `express_company` VALUES (204902, '贝业新兄弟', 'BOYOL', '贝业新兄弟', 222693, 0, '2014-08-13 10:43:39', '2014-08-13 10:43:39', 'BOYOL', '[null]', 0);
INSERT INTO `express_company` VALUES (204904, '合众阳晟', 'YS', '合众阳晟', 1274, 0, '2014-08-13 10:43:39', '2014-08-13 10:43:39', 'YS', '[null]', 0);
INSERT INTO `express_company` VALUES (881232, '众邮快递', 'ZYKD', '众邮快递', 881232, 1, '2020-08-21 09:37:52', '2020-08-21 09:37:56', 'ZYKD', '[null]', 0);
INSERT INTO `express_company` VALUES (10000001, '厂家自送', 'OTHER', '厂家自送', 1274, 1, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'OTHER', '[null]', 0);
INSERT INTO `express_company` VALUES (10000002, '嘉里大通物流', 'OTHER', '嘉里大通物流', 2101, 1, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'OTHER', '[null]', 0);
INSERT INTO `express_company` VALUES (10000003, '中国邮政挂号信', 'OTHER', '中国邮政挂号信', 2171, 1, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'OTHER', '[null]', 0);
INSERT INTO `express_company` VALUES (10000004, '快行线物流', 'OTHER', '快行线物流', 2909, 1, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'OTHER', '[null]', 0);
INSERT INTO `express_company` VALUES (10000005, '微特派', 'OTHER', '微特派', 4605, 1, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'OTHER', '[null]', 0);
INSERT INTO `express_company` VALUES (10000007, '斑马物联网', 'OTHER', '斑马物联网', 6012, 1, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'OTHER', '[null]', 0);
INSERT INTO `express_company` VALUES (10000008, '一智通物流', 'OTHER', '一智通物流', 171683, 1, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'OTHER', '[null]', 0);
INSERT INTO `express_company` VALUES (10000009, '易宅配物流', 'OTHER', '易宅配物流', 171686, 1, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'OTHER', '[null]', 0);
INSERT INTO `express_company` VALUES (10000010, '如风达', '100004928', '如风达', 313214, 1, '2014-08-13 10:43:38', '2014-08-13 10:43:38', '100004928', '[null]', 0);
INSERT INTO `express_company` VALUES (10000011, '上药物流', 'OTHER', '上药物流', 328977, 1, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'OTHER', '[null]', 0);
INSERT INTO `express_company` VALUES (10000012, '海关自提', 'OTHER', '海关自提', 332098, 1, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'OTHER', '[null]', 0);
INSERT INTO `express_company` VALUES (10000013, '京东大件开放承运商', 'OTHER', '京东大件开放承运商', 336878, 1, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'OTHER', '[null]', 0);
INSERT INTO `express_company` VALUES (1566886844, '德邦快运', 'CN7000001009020', '德邦快运', 0, 0, '2019-08-27 14:23:53', '2019-08-27 14:23:53', 'DISTRIBUTOR_13327526', '[null]', 0);
INSERT INTO `express_company` VALUES (21000007003, '美国速递', 'MGSD', '美国速递', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'MGSD', '[null]', 0);
INSERT INTO `express_company` VALUES (21000038002, '派易国际物流77', 'PKGJWL', '派易国际物流77', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'PKGJWL', '[null]', 0);
INSERT INTO `express_company` VALUES (21000046009, 'RUSTON', 'RUSTON', 'RUSTON', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'RUSTON', '[null]', 0);
INSERT INTO `express_company` VALUES (21000046011, 'ZTOSH', 'ZTOSH', 'ZTOSH', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'ZTOSH', '[null]', 0);
INSERT INTO `express_company` VALUES (21000048014, 'ZTOGZ', 'ZTOGZ', 'ZTOGZ', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'ZTOGZ', '[null]', 0);
INSERT INTO `express_company` VALUES (21000051004, '燕文北京', 'YANWENBJ', '燕文北京', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'YANWENBJ', '[null]', 0);
INSERT INTO `express_company` VALUES (21000051006, '燕文义乌', 'YANWENYW', '燕文义乌', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'YANWENYW', '[null]', 0);
INSERT INTO `express_company` VALUES (21000051008, '燕文广州', 'YANWENGZ', '燕文广州', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'YANWENGZ', '[null]', 0);
INSERT INTO `express_company` VALUES (21000052002, '燕文国际', 'YANWENINTE', '燕文国际', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'YANWENINTE', '[null]', 0);
INSERT INTO `express_company` VALUES (21000052004, '燕文上海', 'YANWENSH', '燕文上海', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'YANWENSH', '[null]', 0);
INSERT INTO `express_company` VALUES (21000052006, '燕文深圳', 'YANWENSZ', '燕文深圳', 1274, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'YANWENSZ', '[null]', 0);
INSERT INTO `express_company` VALUES (5000000004901, '安能快递', '2608021499_235', '安能快递', 596494, 1, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'DISTRIBUTOR_12017865', 'ANXB', 0);
INSERT INTO `express_company` VALUES (5000000007756, '邮政国内标准快递', '5000000007756', '邮政国内标准快递', 0, 0, '2019-02-26 20:41:23', '2019-02-26 20:41:30', 'DISTRIBUTOR_1710055', '[null]', 0);
INSERT INTO `express_company` VALUES (5000000110730, '德邦快递', 'DBKD', '德邦快递', 3046, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'DBKD', 'DBKD', 0);
INSERT INTO `express_company` VALUES (5200000110730, '京东快递', 'JD', '京东快递', 2087, 0, '2014-08-13 10:43:38', '2014-08-13 10:43:38', 'JD', 'JD', 0);
INSERT INTO `express_company` VALUES (5300000110730, '菜鸟相关物流', 'OTHER', '菜鸟相关物流', 1274, 0, '2014-08-13 11:43:38', '2014-08-13 11:43:38', 'OTHER', '[null]', 0);
INSERT INTO `express_company` VALUES (5300000110731, '临空物流', 'LKTO', '临空物流', 1274, 0, '2014-08-13 12:43:38', '2014-08-13 12:43:38', 'OTHER', '[null]', 0);
INSERT INTO `express_company` VALUES (5300000110732, '中通快运', '3108002701_1011', '中通快运', 680414, 0, '2018-01-08 09:09:04', '2018-01-08 09:09:04', 'DISTRIBUTOR_13222803', '[null]', 670);
INSERT INTO `express_company` VALUES (5300000110733, '跨越速运', 'CN7000001003751', '跨越速运', 599866, 0, '2018-02-27 20:01:10', '2018-02-27 20:01:10', 'DISTRIBUTOR_13211725', 'KYE', 0);
INSERT INTO `express_company` VALUES (5300000110734, '远成快运', '2460304407_385', '远成快运', 1274, 0, '2018-03-15 19:20:03', '2018-03-15 19:20:03', '2460304407_385', '[null]', 0);
INSERT INTO `express_company` VALUES (5300000110735, '九曳供应链', '2383545689_32', '九曳供应链', 1274, 0, '2018-03-15 19:20:03', '2018-03-15 19:20:03', '2383545689_32', '[null]', 0);
INSERT INTO `express_company` VALUES (5300000110736, '佳吉快运', 'JIAJI', '佳吉快运', 1274, 0, '2018-05-10 19:13:01', '2018-05-10 19:13:01', 'JIAJI', '[null]', 0);
INSERT INTO `express_company` VALUES (5300000110737, '百腾物流', 'OTHER', '百腾物流', 1274, 0, '2018-06-13 19:03:00', '2018-06-13 19:03:00', 'OTHER', '[null]', 0);
INSERT INTO `express_company` VALUES (5300000110738, '盛辉物流', 'OTHER', '盛辉物流', 1274, 0, '2018-06-13 19:03:00', '2018-06-13 19:03:00', 'OTHER', '[null]', 0);
INSERT INTO `express_company` VALUES (5300000110750, '自提', 'ZT', '自提', 1274, 0, '2018-02-27 15:11:49', '2018-02-27 15:11:49', 'OTHER', '[null]', 0);
INSERT INTO `express_company` VALUES (5300000110760, '宇浩物流', 'OTHER', '宇浩物流', 1274, 0, '2018-08-08 19:16:00', '2018-08-08 19:16:00', 'OTHER', '[null]', 0);
INSERT INTO `express_company` VALUES (5300000110780, '壹米滴答', '2744832184_543', '壹米滴答', 1274, 0, '2018-10-08 09:42:03', '2018-10-08 09:42:03', '2744832184_543', '[null]', 0);
INSERT INTO `express_company` VALUES (5300000110790, '圆通承诺达', 'CP468398', '圆通承诺达', 1274, 0, '2018-02-27 15:11:49', '2018-02-27 15:11:49', 'DISTRIBUTOR_13469985', '[null]', 0);
INSERT INTO `express_company` VALUES (5300000110791, '丹鸟', 'CP570969', '丹鸟', 0, 0, '2020-11-26 15:43:51', '2020-11-26 15:43:51', 'DISTRIBUTOR_13503931', '[null]', 0);
INSERT INTO `express_company` VALUES (5300000110792, '丰网速运', 'FENGWANG', '丰网速运', 0, 0, '2021-03-03 19:43:38', '2021-03-03 19:43:38', 'FENGWANG', '[null]', 0);
INSERT INTO `express_company` VALUES (5300000110793, '邮政EMS标准快递', '', '邮政EMS标准快递', 3668, 0, '2021-03-03 20:43:38', '2021-03-03 20:43:38', '', 'EMSBZ', 0);
INSERT INTO `express_company` VALUES (5300000110794, '邮政EMS', '', '邮政EMS', 465, 0, '2021-03-03 21:43:38', '2021-03-03 21:43:38', '', 'EMS', 0);
INSERT INTO `express_company` VALUES (5300000110795, '淘特官方物流', 'CN7000001003876', '淘特官方物流', 0, 0, '2021-07-07 10:43:38', '2021-07-07 10:43:38', 'DISTRIBUTOR_30452995', '[null]', 0);
COMMIT;

-- ----------------------------
-- Table structure for express_company_mapping
-- ----------------------------
DROP TABLE IF EXISTS `express_company_mapping`;
CREATE TABLE `express_company_mapping` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID，自增',
  `source` varchar(128) NOT NULL COMMENT '平台',
  `match_type` varchar(128) DEFAULT NULL COMMENT '平台发货需要的参数类型：1:id 2:code 3:name',
  `platform_biz_id` varchar(128) DEFAULT NULL COMMENT '平台物流公司id',
  `platform_biz_code` varchar(128) DEFAULT NULL COMMENT '平台物流公司编码',
  `platform_biz_name` varchar(128) DEFAULT NULL COMMENT '平台物流公司名称',
  `relative_express_company_id` bigint(11) DEFAULT NULL COMMENT '关联的系统的物流公司ID',
  `sys_biz_code` varchar(128) DEFAULT NULL COMMENT '系统物流公司编码',
  `sys_biz_name` varchar(128) DEFAULT NULL COMMENT '系统物流公司名称',
  `active` tinyint(1) DEFAULT '0' COMMENT '启用状态，1：启用，0未启用，默认为0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `enable_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '数据状态 1：有效 0：无效',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=165 DEFAULT CHARSET=utf8mb4 COMMENT='物流映射关系表';

-- ----------------------------
-- Records of express_company_mapping
-- ----------------------------
BEGIN;
INSERT INTO `express_company_mapping` VALUES (1, 'fxg', '1', '19', 'youzhengguonei', '邮政快递包裹', 1, 'POST', '中国邮政', 1, '2021-07-27 12:02:21', '2021-08-13 09:38:02', 1);
INSERT INTO `express_company_mapping` VALUES (2, 'fxg', '1', '17', 'ems', 'EMS(常用)', 2, 'EMS', 'EMS', 1, '2021-07-27 12:02:21', '2021-08-13 09:39:41', 1);
INSERT INTO `express_company_mapping` VALUES (3, 'fxg', '1', '17', 'ems', 'EMS(常用)', 3, 'EYB', 'EMS经济快递', 1, '2021-07-27 12:02:21', '2021-08-13 09:39:42', 1);
INSERT INTO `express_company_mapping` VALUES (5, 'fxg', '1', '8', 'shentong', '申通快递(常用)', 100, 'STO', '申通快递', 1, '2021-07-27 12:02:21', '2021-08-13 09:40:55', 1);
INSERT INTO `express_company_mapping` VALUES (6, 'fxg', '1', '7', 'yuantong', '圆通快递(常用)', 101, 'YTO', '圆通速递', 1, '2021-07-27 12:02:21', '2021-08-13 09:44:01', 1);
INSERT INTO `express_company_mapping` VALUES (7, 'fxg', '1', '9', 'yunda', '韵达快递(常用)', 102, 'YUNDA', '韵达快递', 1, '2021-07-27 12:02:21', '2021-08-13 09:44:01', 1);
INSERT INTO `express_company_mapping` VALUES (8, 'fxg', '1', '21', 'zhaijisong', '宅急送', 103, 'ZJS', '宅急送', 1, '2021-07-27 12:02:21', '2021-08-13 09:44:01', 1);
INSERT INTO `express_company_mapping` VALUES (9, 'fxg', '1', '20', 'huitongkuaidi', '百世快递(常用)', 105, 'BEST', '百世物流', 1, '2021-07-27 12:02:21', '2021-08-13 09:44:01', 1);
INSERT INTO `express_company_mapping` VALUES (11, 'fxg', '1', '13', 'debangwuliu', '德邦快递(常用)', 107, 'DBL', '德邦物流', 1, '2021-07-27 12:02:21', '2021-08-13 09:44:01', 1);
INSERT INTO `express_company_mapping` VALUES (13, 'fxg', '1', '22', 'rufengda', '如风达', 130, 'RFD', '拼多多:如风达', 1, '2021-07-27 12:02:21', '2021-08-13 09:44:01', 1);
INSERT INTO `express_company_mapping` VALUES (14, 'fxg', '1', '19', 'youzhengguonei', '邮政快递包裹', 132, 'YZXB', '邮政快递包裹', 1, '2021-07-27 12:02:21', '2021-08-13 09:38:04', 1);
INSERT INTO `express_company_mapping` VALUES (16, 'fxg', '1', '31', 'wanxiangwuliu', '万象物流', 142, 'WXWL', '万象物流', 1, '2021-07-27 12:02:21', '2021-08-13 09:44:01', 1);
INSERT INTO `express_company_mapping` VALUES (19, 'fxg', '1', '37', 'huangmajia', '黄马甲', 154, 'HUANGMAJIA', '黄马甲', 1, '2021-07-27 12:02:21', '2021-08-13 09:44:01', 1);
INSERT INTO `express_company_mapping` VALUES (21, 'fxg', '1', '440', 'zhimakaimen', '芝麻开门', 163, 'ZMKM', '芝麻开门', 1, '2021-07-27 12:02:21', '2021-08-13 09:44:01', 1);
INSERT INTO `express_company_mapping` VALUES (26, 'fxg', '1', '151', 'wondersyd', '中邮速递', 211, 'ZHONGYOUWULIU', '中邮速递', 1, '2021-07-27 12:02:21', '2021-08-13 09:44:01', 1);
INSERT INTO `express_company_mapping` VALUES (30, 'fxg', '1', '641', 'rrs', '日日顺物流', 227, 'RRS', '日日顺物流', 1, '2021-07-27 12:02:21', '2021-08-13 09:44:01', 1);
INSERT INTO `express_company_mapping` VALUES (31, 'fxg', '1', '202', 'suning', '苏宁物流', 228, 'SNWL', '苏宁快递', 1, '2021-07-27 12:02:21', '2021-08-13 09:44:01', 1);
INSERT INTO `express_company_mapping` VALUES (41, 'fxg', '1', '10', 'jiayiwuliu', '佳怡物流', 277, 'JIAYI', '佳怡物流', 1, '2021-07-27 12:02:21', '2021-08-13 09:44:01', 1);
INSERT INTO `express_company_mapping` VALUES (42, 'fxg', '1', '517', 'jinguangsudikuaijian', '京广速递', 281, 'CP449455', '京广速递', 1, '2021-07-27 12:02:21', '2021-08-13 09:44:01', 1);
INSERT INTO `express_company_mapping` VALUES (44, 'fxg', '1', '1026', 'sfwl', '盛丰物流', 305, 'FJSFWLJTYXGS', '盛丰物流', 1, '2021-07-27 12:02:21', '2021-08-13 09:44:01', 1);
INSERT INTO `express_company_mapping` VALUES (45, 'fxg', '1', '244', 'shenghuiwuliu', '盛辉物流', 306, 'SHENGHUI', '拼多多:盛辉物流', 1, '2021-07-27 12:02:21', '2021-08-13 09:44:01', 1);
INSERT INTO `express_company_mapping` VALUES (48, 'fxg', '1', '19', 'youzhengguonei', '邮政快递包裹', 324, 'POSTBBZ', '邮政标准快递', 1, '2021-07-27 12:02:21', '2021-08-13 09:38:05', 1);
INSERT INTO `express_company_mapping` VALUES (58, 'fxg', '1', '952', 'yundakuaiyun', '韵达快运', 344, 'CN7000001021040', '韵达快运', 1, '2021-07-27 12:02:21', '2021-08-13 09:45:04', 1);
INSERT INTO `express_company_mapping` VALUES (59, 'fxg', '1', '32', 'annengwuliu', '安能物流', 345, 'CN7000001000869', '安能快运', 1, '2021-07-27 12:02:21', '2021-08-13 09:45:04', 1);
INSERT INTO `express_company_mapping` VALUES (60, 'fxg', '1', '861', 'annto', '安得物流', 346, 'ANDE', '安得物流', 1, '2021-07-27 12:02:21', '2021-08-13 09:45:04', 1);
INSERT INTO `express_company_mapping` VALUES (61, 'fxg', '1', '1023', 'zlxdjwl', '中粮鲜到家物流', 347, 'WM', '中粮我买网', 1, '2021-07-27 12:02:21', '2021-08-13 09:45:04', 1);
INSERT INTO `express_company_mapping` VALUES (62, 'fxg', '1', '897', 'yimidida', '壹米滴答', 348, 'YMDD', '壹米滴答', 1, '2021-07-27 12:02:21', '2021-08-13 09:45:04', 1);
INSERT INTO `express_company_mapping` VALUES (63, 'fxg', '1', '192', 'dangdangorder', '当当', 349, 'DD', '当当网', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (64, 'fxg', '1', '447', 'pjbest', '品骏快递', 350, 'PJ', '品骏', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (66, 'fxg', '1', '631', 'anxl', '安迅物流', 352, 'AXWL', '安迅物流', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:01', 1);
INSERT INTO `express_company_mapping` VALUES (67, 'fxg', '1', '1018', 'dsukuaidi', 'D速快递', 354, 'SDSD', 'D速物流', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (68, 'fxg', '1', '15', 'zhongtong', '中通速递(常用)', 500, 'ZTO', '中通快递', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (69, 'fxg', '1', '20', 'huitongkuaidi', '百世快递(常用)', 502, 'HTKY', '百世汇通', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (70, 'fxg', '1', '14', 'tiantian', '天天快递', 504, 'TTKDEX', '天天快递', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (71, 'fxg', '1', '12', 'shunfeng', '顺丰速运(常用)', 505, 'SF', '顺丰速运', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (76, 'fxg', '1', '140', 'ztky', '中铁快运', 1016, 'CRE', '中铁快运', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (84, 'fxg', '1', '518', 'tiandihuayu', '天地华宇', 1191, 'HOAU', '天地华宇', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (87, 'fxg', '1', '26', 'kuaijiesudi', '快捷快递', 1204, 'FAST', '快捷快递', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (88, 'fxg', '1', '11', 'youshuwuliu', '优速物流', 1207, 'UC', '优速快递', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (89, 'fxg', '1', '23', 'zengyisudi', '增益速递', 1208, 'QRT', '增益速递', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (91, 'fxg', '1', '16', 'quanfengkuaidi', '全峰快递', 1216, 'QFKD', '全峰快递', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (96, 'fxg', '1', '158', 'jym56', '加运美速递', 1270, 'OTHER', '加运美速递', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:01', 1);
INSERT INTO `express_company_mapping` VALUES (97, 'fxg', '1', '1021', 'jtexpress', '极兔速递', 1271, 'JTSD', '极兔速递', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (98, 'fxg', '1', '1024', 'sxjdfreight', '顺心捷达', 12000, 'CP471906', '顺心捷达快运', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (99, 'fxg', '1', '1035', 'shunfengkuaiyun', '顺丰快运', 15000, 'SFKY', '顺丰快运', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:01', 1);
INSERT INTO `express_company_mapping` VALUES (100, 'fxg', '1', '637', 'baishiwuliu', '百世快运', 105031, 'BESTQJT', '百世快运', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (101, 'fxg', '1', '25', 'guotongkuaidi', '国通快递', 200143, 'GTO', '国通快递', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (103, 'fxg', '1', '854', 'yzguonei', '邮政国内', 200734, 'POSTB', '邮政国内小包', 1, '2021-07-27 12:02:21', '2021-08-13 09:38:20', 1);
INSERT INTO `express_company_mapping` VALUES (105, 'fxg', '1', '243', 'suer', '速尔快递', 201174, 'SURE', '速尔', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (111, 'fxg', '1', '1022', 'zhongyouex', '众邮快递', 881232, 'ZYKD', '众邮快递', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (116, 'fxg', '1', '18', 'weitepai', '微特派', 10000005, 'OTHER', '微特派', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (120, 'fxg', '1', '22', 'rufengda', '如风达', 10000010, '100004928', '如风达', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (124, 'fxg', '1', '13', 'debangwuliu', '德邦快递(常用)', 1566886844, 'CN7000001009020', '德邦快运', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (136, 'fxg', '1', '32', 'annengwuliu', '安能物流', 5000000004901, '2608021499_235', '安能快递', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (137, 'fxg', '1', '854', 'yzguonei', '邮政国内', 5000000007756, '5000000007756', '邮政国内标准快递', 1, '2021-07-27 12:02:21', '2021-08-13 09:38:21', 1);
INSERT INTO `express_company_mapping` VALUES (138, 'fxg', '1', '13', 'debangwuliu', '德邦快递(常用)', 5000000110730, 'DBKD', '德邦快递', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (139, 'fxg', '1', '30', 'jd', '京东物流(常用)', 5200000110730, 'JD', '京东快递', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (142, 'fxg', '1', '846', 'zhongtongkuaiyun', '中通快运', 5300000110732, '3108002701_1011', '中通快运', 1, '2021-07-27 12:02:21', '2021-08-13 09:51:02', 1);
INSERT INTO `express_company_mapping` VALUES (143, 'fxg', '1', '397', 'kuayue', '跨越速运', 5300000110733, 'CN7000001003751', '跨越速运', 1, '2021-07-27 12:02:21', '2021-08-13 09:52:27', 1);
INSERT INTO `express_company_mapping` VALUES (145, 'fxg', '1', '191', 'jiuyescm', '九曳供应链', 5300000110735, '2383545689_32', '九曳供应链', 1, '2021-07-27 12:02:21', '2021-08-13 09:52:27', 1);
INSERT INTO `express_company_mapping` VALUES (146, 'fxg', '1', '428', 'jiajiwuliu', '佳吉快运', 5300000110736, 'JIAJI', '佳吉快运', 1, '2021-07-27 12:02:21', '2021-08-13 09:52:27', 1);
INSERT INTO `express_company_mapping` VALUES (148, 'fxg', '1', '244', 'shenghuiwuliu', '盛辉物流', 5300000110738, 'OTHER', '盛辉物流', 1, '2021-07-27 12:02:21', '2021-08-13 09:52:27', 1);
INSERT INTO `express_company_mapping` VALUES (151, 'fxg', '1', '897', 'yimidida', '壹米滴答', 5300000110780, '2744832184_543', '壹米滴答', 1, '2021-07-27 12:02:21', '2021-08-13 09:52:27', 1);
INSERT INTO `express_company_mapping` VALUES (153, 'fxg', '1', '1017', 'danniao', '丹鸟', 5300000110791, 'CP570969', '丹鸟', 1, '2021-07-27 12:02:21', '2021-08-13 09:52:27', 1);
INSERT INTO `express_company_mapping` VALUES (154, 'fxg', '1', '1033', 'fengwang', '丰网速运', 5300000110792, 'FENGWANG', '丰网速运', 1, '2021-07-27 12:02:21', '2021-08-13 09:52:27', 1);
INSERT INTO `express_company_mapping` VALUES (155, 'fxg', '1', '17', 'ems', 'EMS(常用)', 5300000110793, '', '邮政EMS标准快递', 1, '2021-07-27 12:02:21', '2021-08-13 09:39:42', 1);
INSERT INTO `express_company_mapping` VALUES (156, 'fxg', '1', '17', 'ems', 'EMS(常用)', 5300000110794, '', '邮政EMS', 1, '2021-07-27 12:02:21', '2021-08-13 09:39:44', 1);
INSERT INTO `express_company_mapping` VALUES (157, 'mokuai', '1', '19', 'youzhengguonei', '邮政快递包裹', 1, 'POST', '中国邮政', 1, '2021-11-01 17:55:00', '2021-11-01 17:55:00', 1);
INSERT INTO `express_company_mapping` VALUES (158, 'mokuai', '1', '17', 'ems', 'EMS(常用)', 2, 'EMS', 'EMS', 1, '2021-11-01 17:55:35', '2021-11-01 17:55:35', 1);
INSERT INTO `express_company_mapping` VALUES (159, 'mokuai', '1', '19', 'youzhengguonei', '邮政快递包裹', 1, 'POST', '中国邮政', 1, '2021-11-01 18:03:39', '2021-11-01 18:03:39', 1);
INSERT INTO `express_company_mapping` VALUES (160, 'mokuai', '1', '17', 'ems', 'EMS(常用)', 2, 'EMS', 'EMS', 1, '2021-11-01 18:03:39', '2021-11-01 18:03:39', 1);
INSERT INTO `express_company_mapping` VALUES (161, 'mokuai', '1', '19', 'youzhengguonei', '邮政快递包裹', 1, 'POST', '中国邮政', 1, '2021-11-01 18:09:42', '2021-11-01 18:09:42', 1);
INSERT INTO `express_company_mapping` VALUES (162, 'mokuai', '1', '17', 'ems', 'EMS(常用)', 2, 'EMS', 'EMS', 1, '2021-11-01 18:09:42', '2021-11-01 18:09:42', 1);
INSERT INTO `express_company_mapping` VALUES (163, 'mokuai', '1', '19', 'youzhengguonei', '邮政快递包裹', 1, 'POST', '中国邮政', 1, '2021-11-01 18:10:29', '2021-11-01 18:10:29', 1);
INSERT INTO `express_company_mapping` VALUES (164, 'mokuai', '1', '17', 'ems', 'EMS(常用)', 2, 'EMS', 'EMS', 1, '2021-11-01 18:10:29', '2021-11-01 18:10:29', 1);
COMMIT;

-- ----------------------------
-- Table structure for express_company_mapping_base
-- ----------------------------
DROP TABLE IF EXISTS `express_company_mapping_base`;
CREATE TABLE `express_company_mapping_base` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID，自增',
  `source` varchar(128) NOT NULL COMMENT '平台',
  `match_type` varchar(128) DEFAULT NULL COMMENT '平台发货需要的参数类型：1:id 2:code 3:name',
  `platform_biz_id` varchar(128) DEFAULT NULL COMMENT '平台物流公司id',
  `platform_biz_code` varchar(128) DEFAULT NULL COMMENT '平台物流公司编码',
  `platform_biz_name` varchar(128) DEFAULT NULL COMMENT '平台物流公司名称',
  `relative_express_company_id` bigint(11) DEFAULT NULL COMMENT '关联的系统的物流公司ID',
  `sys_biz_code` varchar(128) DEFAULT NULL COMMENT '系统物流公司编码',
  `sys_biz_name` varchar(128) DEFAULT NULL COMMENT '系统物流公司名称',
  `active` tinyint(1) DEFAULT '0' COMMENT '启用状态，1：启用，0未启用，默认为0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `enable_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '数据状态 1：有效 0：无效',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=158 DEFAULT CHARSET=utf8mb4 COMMENT='物流映射关系表';

-- ----------------------------
-- Records of express_company_mapping_base
-- ----------------------------
BEGIN;
INSERT INTO `express_company_mapping_base` VALUES (1, 'fxg', '1', '19', NULL, '邮政快递包裹', 1, 'POST', '中国邮政', 1, '2021-07-27 12:02:21', '2021-08-04 13:43:07', 1);
INSERT INTO `express_company_mapping_base` VALUES (2, 'fxg', '1', '17', NULL, 'EMS(常用)', 2, 'EMS', 'EMS', 1, '2021-07-27 12:02:21', '2021-08-04 11:22:47', 1);
INSERT INTO `express_company_mapping_base` VALUES (3, 'fxg', '1', '17', NULL, 'EMS(常用)', 3, 'EYB', 'EMS经济快递', 1, '2021-07-27 12:02:21', '2021-08-04 11:22:54', 1);
INSERT INTO `express_company_mapping_base` VALUES (5, 'fxg', '1', '8', NULL, '申通快递(常用)', 100, 'STO', '申通快递', 1, '2021-07-27 12:02:21', '2021-07-27 16:58:00', 1);
INSERT INTO `express_company_mapping_base` VALUES (6, 'fxg', '1', '7', NULL, '圆通快递(常用)', 101, 'YTO', '圆通速递', 1, '2021-07-27 12:02:21', '2021-07-27 17:05:24', 1);
INSERT INTO `express_company_mapping_base` VALUES (7, 'fxg', '1', '9', NULL, '韵达快递(常用)', 102, 'YUNDA', '韵达快递', 1, '2021-07-27 12:02:21', '2021-07-27 16:15:04', 1);
INSERT INTO `express_company_mapping_base` VALUES (8, 'fxg', '1', '21', NULL, '宅急送', 103, 'ZJS', '宅急送', 1, '2021-07-27 12:02:21', '2021-07-27 17:12:39', 1);
INSERT INTO `express_company_mapping_base` VALUES (9, 'fxg', '1', '20', NULL, '百世快递(常用)', 105, 'BEST', '百世物流', 1, '2021-07-27 12:02:21', '2021-07-27 17:17:06', 1);
INSERT INTO `express_company_mapping_base` VALUES (10, 'fxg', '1', NULL, NULL, NULL, 106, 'FEDEX', '联邦快递', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (11, 'fxg', '1', '13', NULL, '德邦快递(常用)', 107, 'DBL', '德邦物流', 1, '2021-07-27 12:02:21', '2021-07-27 15:12:49', 1);
INSERT INTO `express_company_mapping_base` VALUES (12, 'fxg', '1', NULL, NULL, NULL, 108, 'SHQ', '华强物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (13, 'fxg', '1', '22', NULL, '如风达', 130, 'RFD', '拼多多:如风达', 1, '2021-07-27 12:02:21', '2021-08-04 13:51:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (14, 'fxg', '1', '19', NULL, '邮政快递包裹', 132, 'YZXB', '邮政快递包裹', 1, '2021-07-27 12:02:21', '2021-07-27 17:12:17', 1);
INSERT INTO `express_company_mapping_base` VALUES (15, 'fxg', '1', NULL, NULL, NULL, 140, 'NJCHENGBANG', '南京晟邦', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (16, 'fxg', '1', '31', NULL, '万象物流', 142, 'WXWL', '万象物流', 1, '2021-07-27 12:02:21', '2021-07-27 17:20:06', 1);
INSERT INTO `express_company_mapping_base` VALUES (17, 'fxg', '1', NULL, NULL, NULL, 148, 'ADX', '安达信', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (18, 'fxg', '1', NULL, NULL, NULL, 149, 'HWKD', '海外快递', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (19, 'fxg', '1', '37', NULL, '黄马甲', 154, 'HUANGMAJIA', '黄马甲', 1, '2021-07-27 12:02:21', '2021-07-27 17:10:01', 1);
INSERT INTO `express_company_mapping_base` VALUES (20, 'fxg', '1', NULL, NULL, NULL, 156, 'YAMAXUNWULIU', '亚马逊物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (21, 'fxg', '1', '440', NULL, '芝麻开门', 163, 'ZMKM', '芝麻开门', 1, '2021-07-27 12:02:21', '2021-07-27 16:10:42', 1);
INSERT INTO `express_company_mapping_base` VALUES (22, 'fxg', '1', NULL, NULL, NULL, 165, 'HTXMJ', '汇通小红马', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (23, 'fxg', '1', NULL, NULL, NULL, 180, 'SELF', '拼多多:其他', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (24, 'fxg', '1', NULL, NULL, NULL, 187, 'ANJELEX', '青岛安捷', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (25, 'fxg', '1', NULL, NULL, NULL, 205, 'YCGWL', '远成快运', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (26, 'fxg', '1', '151', NULL, '中邮速递', 211, 'ZHONGYOUWULIU', '中邮速递', 1, '2021-07-27 12:02:21', '2021-07-27 16:54:42', 1);
INSERT INTO `express_company_mapping_base` VALUES (27, 'fxg', '1', NULL, NULL, NULL, 213, 'INTEREMS', 'EMS-国际件', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (28, 'fxg', '1', NULL, NULL, NULL, 214, 'ZTKY', '中铁物流(飞豹)', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (29, 'fxg', '1', NULL, NULL, NULL, 217, 'FLASH', 'Flash Express', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (30, 'fxg', '1', '641', NULL, '日日顺物流', 227, 'RRS', '日日顺物流', 1, '2021-07-27 12:02:21', '2021-07-27 17:19:00', 1);
INSERT INTO `express_company_mapping_base` VALUES (31, 'fxg', '1', '202', NULL, '苏宁物流', 228, 'SNWL', '苏宁快递', 1, '2021-07-27 12:02:21', '2021-07-27 17:03:06', 1);
INSERT INTO `express_company_mapping_base` VALUES (32, 'fxg', '1', NULL, NULL, NULL, 231, 'WEITEPAI', '拼多多:微特派', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (33, 'fxg', '1', NULL, NULL, NULL, 232, 'MYAAE', 'AAE全球专递', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (34, 'fxg', '1', NULL, NULL, NULL, 233, 'ARAMEX', 'Aramex', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (35, 'fxg', '1', NULL, NULL, NULL, 239, 'DHLCN', 'DHL中国', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (36, 'fxg', '1', NULL, NULL, NULL, 246, 'UPS', 'UPS', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (37, 'fxg', '1', NULL, NULL, NULL, 262, 'CXCOD', '传喜物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (38, 'fxg', '1', NULL, NULL, NULL, 264, '4PX', '递四方', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (39, 'fxg', '1', NULL, NULL, NULL, 273, 'HLWL', '恒路物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (40, 'fxg', '1', NULL, NULL, NULL, 275, 'TMS56', '加运美', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (41, 'fxg', '1', '10', NULL, '佳怡物流', 277, 'JIAYI', '佳怡物流', 1, '2021-07-27 12:02:21', '2021-07-27 17:19:17', 1);
INSERT INTO `express_company_mapping_base` VALUES (42, 'fxg', '1', '517', NULL, '京广速递', 281, 'CP449455', '京广速递', 1, '2021-07-27 12:02:21', '2021-07-27 17:15:02', 1);
INSERT INTO `express_company_mapping_base` VALUES (43, 'fxg', '1', NULL, NULL, NULL, 291, 'CAE', '民航快递', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (44, 'fxg', '1', '1026', NULL, '盛丰物流', 305, 'FJSFWLJTYXGS', '盛丰物流', 1, '2021-07-27 12:02:21', '2021-07-27 17:06:02', 1);
INSERT INTO `express_company_mapping_base` VALUES (45, 'fxg', '1', NULL, NULL, NULL, 306, 'SHENGHUI', '拼多多:盛辉物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (46, 'fxg', '1', NULL, NULL, NULL, 312, 'MANCOWL', '万家物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (47, 'fxg', '1', NULL, NULL, NULL, 319, 'YWWL', '燕文物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (48, 'fxg', '1', '19', NULL, '邮政快递包裹', 324, 'POSTBBZ', '邮政标准快递', 1, '2021-07-27 12:02:21', '2021-08-04 13:43:40', 1);
INSERT INTO `express_company_mapping_base` VALUES (49, 'fxg', '1', NULL, NULL, NULL, 325, 'CNPOSTGJ', '邮政国际包裹', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (50, 'fxg', '1', NULL, NULL, NULL, 335, 'YOUBANG', '优邦国际速运', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (51, 'fxg', '1', NULL, NULL, NULL, 336, 'TJ', '天际快递', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (52, 'fxg', '1', NULL, NULL, NULL, 337, 'FY', '飞洋快递', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (53, 'fxg', '1', NULL, NULL, NULL, 338, 'BM', '拼多多:斑马物联网', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (54, 'fxg', '1', NULL, NULL, NULL, 339, 'EKM', '易客满', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (55, 'fxg', '1', NULL, NULL, NULL, 340, 'JDKD', '京东大件物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (56, 'fxg', '1', NULL, NULL, NULL, 341, 'SUBIDA', '速必达', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (57, 'fxg', '1', NULL, NULL, NULL, 342, 'DJKJWL', '东骏快捷', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (58, 'fxg', '1', '952', NULL, '韵达快运', 344, 'CN7000001021040', '韵达快运', 1, '2021-07-27 12:02:21', '2021-07-27 16:15:04', 1);
INSERT INTO `express_company_mapping_base` VALUES (59, 'fxg', '1', '32', NULL, '安能物流', 345, 'CN7000001000869', '安能快运', 1, '2021-07-27 12:02:21', '2021-07-27 17:11:06', 1);
INSERT INTO `express_company_mapping_base` VALUES (60, 'fxg', '1', '861', NULL, '安得物流', 346, 'ANDE', '安得物流', 1, '2021-07-27 12:02:21', '2021-07-27 16:13:29', 1);
INSERT INTO `express_company_mapping_base` VALUES (61, 'fxg', '1', '1023', NULL, '中粮鲜到家物流', 347, 'WM', '中粮我买网', 1, '2021-07-27 12:02:21', '2021-07-27 17:10:34', 1);
INSERT INTO `express_company_mapping_base` VALUES (62, 'fxg', '1', '897', NULL, '壹米滴答', 348, 'YMDD', '壹米滴答', 1, '2021-07-27 12:02:21', '2021-07-27 17:03:59', 1);
INSERT INTO `express_company_mapping_base` VALUES (63, 'fxg', '1', '192', NULL, '当当', 349, 'DD', '当当网', 1, '2021-07-27 12:02:21', '2021-07-27 16:57:04', 1);
INSERT INTO `express_company_mapping_base` VALUES (64, 'fxg', '1', '447', NULL, '品骏快递', 350, 'PJ', '品骏', 1, '2021-07-27 12:02:21', '2021-07-27 17:13:38', 1);
INSERT INTO `express_company_mapping_base` VALUES (65, 'fxg', '1', NULL, NULL, NULL, 351, 'OTP', '承诺达特快', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (66, 'fxg', '1', '631', NULL, '安迅物流', 352, 'AXWL', '安迅物流', 1, '2021-07-27 12:02:21', '2021-07-27 17:01:03', 1);
INSERT INTO `express_company_mapping_base` VALUES (67, 'fxg', '1', '1018', NULL, 'D速快递', 354, 'SDSD', 'D速物流', 1, '2021-07-27 12:02:21', '2021-07-27 16:59:22', 1);
INSERT INTO `express_company_mapping_base` VALUES (68, 'fxg', '1', '15', NULL, '中通速递(常用)', 500, 'ZTO', '中通快递', 1, '2021-07-27 12:02:21', '2021-07-27 16:55:44', 1);
INSERT INTO `express_company_mapping_base` VALUES (69, 'fxg', '1', '20', NULL, '百世快递(常用)', 502, 'HTKY', '百世汇通', 1, '2021-07-27 12:02:21', '2021-07-27 17:17:06', 1);
INSERT INTO `express_company_mapping_base` VALUES (70, 'fxg', '1', '14', NULL, '天天快递', 504, 'TTKDEX', '天天快递', 1, '2021-07-27 12:02:21', '2021-07-27 17:09:44', 1);
INSERT INTO `express_company_mapping_base` VALUES (71, 'fxg', '1', '12', NULL, '顺丰速运(常用)', 505, 'SF', '顺丰速运', 1, '2021-07-27 12:02:21', '2021-07-27 17:09:13', 1);
INSERT INTO `express_company_mapping_base` VALUES (72, 'fxg', '1', NULL, NULL, NULL, 507, 'AIR', '亚风', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (73, 'fxg', '1', NULL, NULL, NULL, 511, 'CYEXP', '长宇', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (74, 'fxg', '1', NULL, NULL, NULL, 512, 'DTW', '大田', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (75, 'fxg', '1', NULL, NULL, NULL, 513, 'YUD', '长发', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (76, 'fxg', '1', '140', NULL, '中铁快运', 1016, 'CRE', '中铁快运', 1, '2021-07-27 12:02:21', '2021-07-27 16:54:05', 1);
INSERT INTO `express_company_mapping_base` VALUES (77, 'fxg', '1', NULL, NULL, NULL, 1056, 'CNEX', '佳吉快递', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (78, 'fxg', '1', NULL, NULL, NULL, 1121, 'HZABC', '飞远(爱彼西)配送', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (79, 'fxg', '1', NULL, NULL, NULL, 1137, 'DFH', '东方汇', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (80, 'fxg', '1', NULL, NULL, NULL, 1138, 'SY', '首业', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (81, 'fxg', '1', NULL, NULL, NULL, 1139, 'YC', '远长', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (82, 'fxg', '1', NULL, NULL, NULL, 1185, 'YCT', '黑猫宅急便', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (83, 'fxg', '1', NULL, NULL, NULL, 1186, 'XB', '新邦物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (84, 'fxg', '1', '518', NULL, '天地华宇', 1191, 'HOAU', '天地华宇', 1, '2021-07-27 12:02:21', '2021-07-27 17:21:50', 1);
INSERT INTO `express_company_mapping_base` VALUES (85, 'fxg', '1', NULL, NULL, NULL, 1192, 'NEDA', '能达速递', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (86, 'fxg', '1', NULL, NULL, NULL, 1195, 'LB', '龙邦速递', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (87, 'fxg', '1', '26', NULL, '快捷快递', 1204, 'FAST', '快捷快递', 1, '2021-07-27 12:02:21', '2021-07-27 15:18:08', 1);
INSERT INTO `express_company_mapping_base` VALUES (88, 'fxg', '1', '11', NULL, '优速物流', 1207, 'UC', '优速快递', 1, '2021-07-27 12:02:21', '2021-07-27 17:19:40', 1);
INSERT INTO `express_company_mapping_base` VALUES (89, 'fxg', '1', '23', NULL, '增益速递', 1208, 'QRT', '增益速递', 1, '2021-07-27 12:02:21', '2021-07-27 15:20:52', 1);
INSERT INTO `express_company_mapping_base` VALUES (90, 'fxg', '1', NULL, NULL, NULL, 1214, 'LTS', '联昊通', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (91, 'fxg', '1', '16', NULL, '全峰快递', 1216, 'QFKD', '全峰快递', 1, '2021-07-27 12:02:21', '2021-07-27 16:16:42', 1);
INSERT INTO `express_company_mapping_base` VALUES (92, 'fxg', '1', NULL, NULL, NULL, 1237, 'UNIPS', '发网', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (93, 'fxg', '1', NULL, NULL, NULL, 1259, 'UAPEX', '全一快递', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (94, 'fxg', '1', NULL, NULL, NULL, 1262, 'BJCS', '城市100', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (95, 'fxg', '1', NULL, NULL, NULL, 1269, 'GDEMS', '广东EMS', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (96, 'fxg', '1', '158', NULL, '加运美速递', 1270, 'OTHER', '加运美速递', 1, '2021-07-27 12:02:21', '2021-07-27 17:13:14', 1);
INSERT INTO `express_company_mapping_base` VALUES (97, 'fxg', '1', '1021', NULL, '极兔速递', 1271, 'JTSD', '极兔速递', 1, '2021-07-27 12:02:21', '2021-07-27 16:14:00', 1);
INSERT INTO `express_company_mapping_base` VALUES (98, 'fxg', '1', '1024', NULL, '顺心捷达', 12000, 'CP471906', '顺心捷达快运', 1, '2021-07-27 12:02:21', '2021-07-27 17:02:14', 1);
INSERT INTO `express_company_mapping_base` VALUES (99, 'fxg', '1', '1035', NULL, '顺丰快运', 15000, 'SFKY', '顺丰快运', 1, '2021-07-27 12:02:21', '2021-07-27 17:09:13', 1);
INSERT INTO `express_company_mapping_base` VALUES (100, 'fxg', '1', '637', NULL, '百世快运', 105031, 'BESTQJT', '百世快运', 1, '2021-07-27 12:02:21', '2021-07-27 17:08:28', 1);
INSERT INTO `express_company_mapping_base` VALUES (101, 'fxg', '1', '25', NULL, '国通快递', 200143, 'GTO', '国通快递', 1, '2021-07-27 12:02:21', '2021-07-27 17:02:35', 1);
INSERT INTO `express_company_mapping_base` VALUES (102, 'fxg', '1', NULL, NULL, NULL, 200427, 'GZLT', '飞远配送 ', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (103, 'fxg', '1', '854', NULL, '邮政国内', 200734, 'POSTB', '邮政国内小包', 1, '2021-07-27 12:02:21', '2021-07-27 17:01:39', 1);
INSERT INTO `express_company_mapping_base` VALUES (104, 'fxg', '1', NULL, NULL, NULL, 200740, 'ESB', 'E速宝', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (105, 'fxg', '1', '243', NULL, '速尔快递', 201174, 'SURE', '速尔', 1, '2021-07-27 12:02:21', '2021-07-27 17:06:40', 1);
INSERT INTO `express_company_mapping_base` VALUES (106, 'fxg', '1', NULL, NULL, NULL, 202855, 'XFWL', '信丰物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (107, 'fxg', '1', NULL, NULL, NULL, 202857, 'GZFY', '凡宇速递', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (108, 'fxg', '1', NULL, NULL, NULL, 204900, 'JWY', '居无忧', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (109, 'fxg', '1', NULL, NULL, NULL, 204902, 'BOYOL', '贝业新兄弟', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (110, 'fxg', '1', NULL, NULL, NULL, 204904, 'YS', '合众阳晟', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (111, 'fxg', '1', '1022', NULL, '众邮快递', 881232, 'ZYKD', '众邮快递', 1, '2021-07-27 12:02:21', '2021-07-27 17:17:48', 1);
INSERT INTO `express_company_mapping_base` VALUES (112, 'fxg', '1', NULL, NULL, NULL, 10000001, 'OTHER', '厂家自送', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (113, 'fxg', '1', NULL, NULL, NULL, 10000002, 'OTHER', '嘉里大通物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (114, 'fxg', '1', NULL, NULL, NULL, 10000003, 'OTHER', '中国邮政挂号信', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (115, 'fxg', '1', NULL, NULL, NULL, 10000004, 'OTHER', '快行线物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (116, 'fxg', '1', '18', NULL, '微特派', 10000005, 'OTHER', '微特派', 1, '2021-07-27 12:02:21', '2021-07-27 17:07:54', 1);
INSERT INTO `express_company_mapping_base` VALUES (117, 'fxg', '1', NULL, NULL, NULL, 10000007, 'OTHER', '斑马物联网', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (118, 'fxg', '1', NULL, NULL, NULL, 10000008, 'OTHER', '一智通物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (119, 'fxg', '1', NULL, NULL, NULL, 10000009, 'OTHER', '易宅配物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (120, 'fxg', '1', '22', NULL, '如风达', 10000010, '100004928', '如风达', 1, '2021-07-27 12:02:21', '2021-07-27 16:53:34', 1);
INSERT INTO `express_company_mapping_base` VALUES (121, 'fxg', '1', NULL, NULL, NULL, 10000011, 'OTHER', '上药物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (122, 'fxg', '1', NULL, NULL, NULL, 10000012, 'OTHER', '海关自提', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (123, 'fxg', '1', NULL, NULL, NULL, 10000013, 'OTHER', '京东大件开放承运商', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (124, 'fxg', '1', '13', NULL, '德邦快递(常用)', 1566886844, 'CN7000001009020', '德邦快运', 1, '2021-07-27 12:02:21', '2021-07-27 15:13:10', 1);
INSERT INTO `express_company_mapping_base` VALUES (125, 'fxg', '1', NULL, NULL, NULL, 21000007003, 'MGSD', '美国速递', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (126, 'fxg', '1', NULL, NULL, NULL, 21000038002, 'PKGJWL', '派易国际物流77', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (127, 'fxg', '1', NULL, NULL, NULL, 21000046009, 'RUSTON', 'RUSTON', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (128, 'fxg', '1', NULL, NULL, NULL, 21000046011, 'ZTOSH', 'ZTOSH', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (129, 'fxg', '1', NULL, NULL, NULL, 21000048014, 'ZTOGZ', 'ZTOGZ', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (130, 'fxg', '1', NULL, NULL, NULL, 21000051004, 'YANWENBJ', '燕文北京', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (131, 'fxg', '1', NULL, NULL, NULL, 21000051006, 'YANWENYW', '燕文义乌', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (132, 'fxg', '1', NULL, NULL, NULL, 21000051008, 'YANWENGZ', '燕文广州', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (133, 'fxg', '1', NULL, NULL, NULL, 21000052002, 'YANWENINTE', '燕文国际', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (134, 'fxg', '1', NULL, NULL, NULL, 21000052004, 'YANWENSH', '燕文上海', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (135, 'fxg', '1', NULL, NULL, NULL, 21000052006, 'YANWENSZ', '燕文深圳', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (136, 'fxg', '1', '32', NULL, '安能物流', 5000000004901, '2608021499_235', '安能快递', 1, '2021-07-27 12:02:21', '2021-07-27 17:11:22', 1);
INSERT INTO `express_company_mapping_base` VALUES (137, 'fxg', '1', '854', NULL, '邮政国内', 5000000007756, '5000000007756', '邮政国内标准快递', 1, '2021-07-27 12:02:21', '2021-07-27 17:01:39', 1);
INSERT INTO `express_company_mapping_base` VALUES (138, 'fxg', '1', '13', NULL, '德邦快递(常用)', 5000000110730, 'DBKD', '德邦快递', 1, '2021-07-27 12:02:21', '2021-07-27 15:13:11', 1);
INSERT INTO `express_company_mapping_base` VALUES (139, 'fxg', '1', '30', NULL, '京东物流(常用)', 5200000110730, 'JD', '京东快递', 1, '2021-07-27 12:02:21', '2021-07-27 15:23:34', 1);
INSERT INTO `express_company_mapping_base` VALUES (140, 'fxg', '1', NULL, NULL, NULL, 5300000110730, 'OTHER', '菜鸟相关物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (141, 'fxg', '1', NULL, NULL, NULL, 5300000110731, 'LKTO', '临空物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (142, 'fxg', '1', '846', NULL, '中通快运', 5300000110732, '3108002701_1011', '中通快运', 1, '2021-07-27 12:02:21', '2021-07-27 16:55:44', 1);
INSERT INTO `express_company_mapping_base` VALUES (143, 'fxg', '1', '397', NULL, '跨越速运', 5300000110733, 'CN7000001003751', '跨越速运', 1, '2021-07-27 12:02:21', '2021-07-27 17:21:30', 1);
INSERT INTO `express_company_mapping_base` VALUES (144, 'fxg', '1', NULL, NULL, NULL, 5300000110734, '2460304407_385', '远成快运', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (145, 'fxg', '1', '191', NULL, '九曳供应链', 5300000110735, '2383545689_32', '九曳供应链', 1, '2021-07-27 12:02:21', '2021-07-27 17:11:51', 1);
INSERT INTO `express_company_mapping_base` VALUES (146, 'fxg', '1', '428', NULL, '佳吉快运', 5300000110736, 'JIAJI', '佳吉快运', 1, '2021-07-27 12:02:21', '2021-07-27 16:58:50', 1);
INSERT INTO `express_company_mapping_base` VALUES (147, 'fxg', '1', NULL, NULL, NULL, 5300000110737, 'OTHER', '百腾物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (148, 'fxg', '1', '244', NULL, '盛辉物流', 5300000110738, 'OTHER', '盛辉物流', 1, '2021-07-27 12:02:21', '2021-07-27 17:21:05', 1);
INSERT INTO `express_company_mapping_base` VALUES (149, 'fxg', '1', NULL, NULL, NULL, 5300000110750, 'ZT', '自提', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (150, 'fxg', '1', NULL, NULL, NULL, 5300000110760, 'OTHER', '宇浩物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (151, 'fxg', '1', '897', NULL, '壹米滴答', 5300000110780, '2744832184_543', '壹米滴答', 1, '2021-07-27 12:02:21', '2021-07-27 17:03:59', 1);
INSERT INTO `express_company_mapping_base` VALUES (152, 'fxg', '1', NULL, NULL, NULL, 5300000110790, 'CP468398', '圆通承诺达', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (153, 'fxg', '1', '1017', NULL, '丹鸟', 5300000110791, 'CP570969', '丹鸟', 1, '2021-07-27 12:02:21', '2021-07-27 17:15:18', 1);
INSERT INTO `express_company_mapping_base` VALUES (154, 'fxg', '1', '1033', NULL, '丰网速运', 5300000110792, 'FENGWANG', '丰网速运', 1, '2021-07-27 12:02:21', '2021-07-27 17:23:06', 1);
INSERT INTO `express_company_mapping_base` VALUES (155, 'fxg', '1', NULL, NULL, NULL, 5300000110793, '', '邮政EMS标准快递', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (156, 'fxg', '1', NULL, NULL, NULL, 5300000110794, '', '邮政EMS', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
INSERT INTO `express_company_mapping_base` VALUES (157, 'fxg', '1', NULL, NULL, NULL, 5300000110795, 'CN7000001003876', '淘特官方物流', 1, '2021-07-27 12:02:21', '2021-07-27 12:02:21', 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
